SELECT FORMMAIN_2118."ID",FORMMAIN_2118.FIELD0002 supplierName,FORMMAIN_2118.FIELD0003 supplierCode FROM FORMMAIN_2118 
LEFT JOIN COL_SUMMARY ON COL_SUMMARY.FORM_RECORDID = FORMMAIN_2118."ID"
WHERE COL_SUMMARY."ID" = '${id}' AND FORMMAIN_2118.FIELD0009 = '8085910539499752073'